9.0.01 ODBC driver return values changed for sqlGetTypeInfo
am 27.10.2010 01:08:29 von the6campbells--20cf301d3ed0df92eb04938d2fbc
Content-Type: text/plain; charset=ISO-8859-1
http://msdn.microsoft.com/en-us/library/ms714632(v=VS.85).as px
Using 8.4.2 driver on Windows
SQL_SUCCESS = SQLGetTypeInfo(StatementHandle = 0x36017c0,DataType
= SQL_ALL_TYPES)
SQL_SUCCESS = SQLBindCol(Statement Handle = 0x36017c0,ColumnNumber
= 1,TargetType = SQL_C_CHAR ,TargetValuePtr = 0x12c0b4,BufferLength =
1028,StrLen_or_IndPtr = 2084091336)
......
SQL_SUCCESS = SQLBindCol(Statement Handle = 0x36017c0,ColumnNumber
= 19,TargetType = SQL_C_SHORT ,TargetValuePtr = 0x12d544,BufferLength =
2,StrLen_or_IndPtr = 1230120)
SQL_SUCCESS = SQLFetch(StatementHandle = 0x36017c0)
Row=0,TYPE_NAME ,Type=SQL_C_CHAR ,bufLen=1028,size=4,data=int8
Row=0,DATA_TYPE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=-5
Row=0,COLUMN_SIZE ,Type=SQL_C_LONG ,bufLen=4,size=4,data=19
Row=0,LITERAL_PREFIX ,Type=SQL_C_CHAR
,bufLen=1028,size=-1,data=(NULL)
Row=0,LITERAL_SUFFIX ,Type=SQL_C_CHAR
,bufLen=1028,size=-1,data=(NULL)
Row=0,CREATE_PARAMS ,Type=SQL_C_CHAR
,bufLen=1028,size=-1,data=(NULL)
Row=0,NULLABLE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=1
Row=0,CASE_SENSITIVE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Row=0,SEARCHABLE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=2
Row=0,UNSIGNED_ATTRIBUTE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Row=0,FIXED_PREC_SCALE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Row=0,AUTO_UNIQUE_VALUE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Row=0,LOCAL_TYPE_NAME ,Type=SQL_C_CHAR
,bufLen=1028,size=-1,data=(NULL)
Row=0,MINIMUM_SCALE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Row=0,MAXIMUM_SCALE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Row=0,SQL_DATA_TYPE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=-5
Row=0,SQL_DATETIME_SUB ,Type=SQL_C_LONG ,bufLen=4,size=-1,data=(NULL)
Row=0,NUM_PREC_RADIX ,Type=SQL_C_LONG ,bufLen=4,size=4,data=10
Row=0,INTERVAL_PRECISION ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Using 9.0.01 driver on Windows
SQL_SUCCESS = SQLBindCol(Statement Handle = 0x36017c0,ColumnNumber
= 19,TargetType = SQL_C_SHORT ,TargetValuePtr = 0x12d544,BufferLength =
2,StrLen_or_IndPtr = 1230120)
SQL_SUCCESS = SQLFetch(StatementHandle = 0x36017c0)
Row=0,TYPE_NAME ,Type=SQL_C_CHAR ,bufLen=1028,size=4,data=int8
Row=0,DATA_TYPE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=-5
Row=0,COLUMN_SIZE ,Type=SQL_C_LONG ,bufLen=4,size=4,data=19
Row=0,LITERAL_PREFIX ,Type=SQL_C_CHAR
,bufLen=1028,size=-1,data=(NULL)
Row=0,LITERAL_SUFFIX ,Type=SQL_C_CHAR
,bufLen=1028,size=-1,data=(NULL)
Row=0,CREATE_PARAMS ,Type=SQL_C_CHAR
,bufLen=1028,size=-1,data=(NULL)
Row=0,NULLABLE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=1
Row=0,CASE_SENSITIVE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Row=0,SEARCHABLE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=2
Row=0,UNSIGNED_ATTRIBUTE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Row=0,FIXED_PREC_SCALE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Row=0,AUTO_UNIQUE_VALUE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Row=0,LOCAL_TYPE_NAME ,Type=SQL_C_CHAR
,bufLen=1028,size=-1,data=(NULL)
Row=0,MINIMUM_SCALE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Row=0,MAXIMUM_SCALE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
Row=0,SQL_DATA_TYPE ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=-5
Row=0,SQL_DATETIME_SUB ,Type=SQL_C_LONG ,bufLen=4,size=4,data=-5
<--------- DIFF
Row=0,NUM_PREC_RADIX ,Type=SQL_C_LONG ,bufLen=4,size=4,data=10
Row=0,INTERVAL_PRECISION ,Type=SQL_C_SHORT ,bufLen=2,size=2,data=0
--20cf301d3ed0df92eb04938d2fbc
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
div>
SQL_SUCCESS =A0 =A0 =A0 =A0 =A0 =3D SQLGetTypeInfo(StatementHandle =3D 0x36=
017c0,DataType =3D SQL_ALL_TYPES)
=3D SQLBindCol(Statement Handle =3D 0x36017c0,ColumnNumber =3D 1,TargetTyp=
e =3D SQL_C_CHAR =A0 =A0 ,TargetValuePtr =3D 0x12c0b4,BufferLength =3D 1028=
,StrLen_or_IndPtr =3D 2084091336)
nt Handle =3D 0x36017c0,ColumnNumber =3D 19,TargetType =3D SQL_C_SHORT =A0 =
=A0,TargetValuePtr =3D 0x12d544,BufferLength =3D 2,StrLen_or_IndPtr =3D 123=
0120)
e =3D 0x36017c0)
fLen=3D1028,size=3D4,data=3Dint8
=A0 =A0,Type=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,size=3D2,data=3D-5
=3D4,size=3D4,data=3D19
=3D1028,size=3D-1,data=3D(NULL)
,Type=3DSQL_C_CHAR =A0 =A0 ,bufLen=3D1028,size=3D-1,data=3D(NULL)
1028,size=3D-1,data=3D(NULL)
fLen=3D2,size=3D2,data=3D1
e=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,size=3D2,data=3D0
EARCHABLE =A0 =A0 =A0 =A0 ,Type=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,size=3D2,d=
ata=3D2
ize=3D2,data=3D0
ORT =A0 =A0,bufLen=3D2,size=3D2,data=3D0
ALUE =A0,Type=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,size=3D2,data=3D0
=3D1028,size=3D-1,data=3D(NULL)
=A0,Type=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,size=3D2,data=3D0
w=3D0,MAXIMUM_SCALE =A0 =A0 =A0,Type=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,size=
=3D2,data=3D0
=3D2,size=3D2,data=3D-5
QL_C_LONG =A0 =A0 ,bufLen=3D4,size=3D-1,data=3D(NULL)
NUM_PREC_RADIX =A0 =A0 ,Type=3DSQL_C_LONG =A0 =A0 ,bufLen=3D4,size=3D4,data=
=3D10
ize=3D2,data=3D0
driver on Windows
=A0 =A0 =3D SQLBindCol(Statement Handle =3D 0x36017c0,ColumnNumber =3D 19,T=
argetType =3D SQL_C_SHORT =A0 =A0,TargetValuePtr =3D 0x12d544,BufferLength =
=3D 2,StrLen_or_IndPtr =3D 1230120)
17c0)
=A0 =A0 ,bufLen=3D1028,size=3D4,data=3Dint8
=A0 =A0 =A0 =A0 =A0,Type=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,size=3D2,data=3D-=
5
en=3D4,size=3D4,data=3D19
=3DSQL_C_CHAR =A0 =A0 ,bufLen=3D1028,size=3D-1,data=3D(NULL)
ow=3D0,LITERAL_SUFFIX =A0 =A0 ,Type=3DSQL_C_CHAR =A0 =A0 ,bufLen=3D1028,siz=
e=3D-1,data=3D(NULL)
=3D1028,size=3D-1,data=3D(NULL)
=A0 =A0 ,Type=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,size=3D2,data=3D1
=A0Row=3D0,CASE_SENSITIVE =A0 =A0 ,Type=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,si=
ze=3D2,data=3D0
en=3D2,size=3D2,data=3D2
L_C_SHORT =A0 =A0,bufLen=3D2,size=3D2,data=3D0
REC_SCALE =A0 ,Type=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,size=3D2,data=3D0
,size=3D2,data=3D0
C_CHAR =A0 =A0 ,bufLen=3D1028,size=3D-1,data=3D(NULL)
MINIMUM_SCALE =A0 =A0 =A0,Type=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,size=3D2,da=
ta=3D0
=3D2,size=3D2,data=3D0
=3DSQL_C_SHORT =A0 =A0,bufLen=3D2,size=3D2,data=3D-5
QL_DATETIME_SUB =A0 ,Type=3DSQL_C_LONG =A0 =A0 ,bufLen=3D4,size=3D4,data=3D=
-5 <--------- DIFF
=3D4,size=3D4,data=3D10
_C_SHORT =A0 =A0,bufLen=3D2,size=3D2,data=3D0
--20cf301d3ed0df92eb04938d2fbc--